create external table jms_ods.scan_network_config (
    ID                 bigint    comment ''
    ,NETWORK_ID         bigint    comment '网点id'
    ,NETWORK_CODE       string    comment '网点code'
    ,NETWORK_NAME       string    comment '网点名称'
    ,SCAN_TYPE          string    comment '扫描类型'
    ,USE_NETWORK_ID     bigint    comment '补录网点id'
    ,USE_NETWORK_CODE   string    comment '补录网点编号'
    ,USE_NETWORK_NAME   string    comment '补录网点名称'
    ,USE_SCAN_TYPE      string    comment '补录扫描类型'
    ,SCAN_LIMIT_TIME    bigint    comment '间隔时间'
    ,RECEIVER_NAME      string    comment '收件员'
    ,STATUS             bigint    comment '状态：1可用，2禁用'
    ,RECEIVER_CODE      string    comment '取件员编号'
    ,RECEIVER_ID        bigint    comment '取件员id'
    ,RECEIVER_PHONE     string    comment '取件员电话'
    ,USE_OPERATION_TYPE string    comment '生成扫描类型'
    ,STAFF_CODE         string    comment '员工编号'
    ,STAFF_NAME         string    comment '员工名称'
    ,CREATE_TIME        timestamp    comment '创建时间'
    ,UPDATE_TIME        timestamp    comment '修改时间'
    ,CREATE_CODE        string    comment '创建用户code'
    ,CREATE_NAME        string    comment '创建用户名称'
    ,UPDATE_CODE        string    comment '修改用户code'
    ,UPDATE_NAME        string    comment '修改用户name'
    ,ENABLE_TIME        timestamp    comment '启用时间'
    ,DISABLE_TIME       timestamp    comment '禁用时间'
) comment'扫描网点配置'
PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/scan_network_config'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);